ALTER TABLE [dbo].[stock_count_record] DROP COLUMN [materialSum], COLUMN [nextMaterial], COLUMN [deductionSum], COLUMN [next_type], COLUMN [defective]
    GO

ALTER TABLE [dbo].[stock_count_record] ADD [last_material] varchar(255) NULL
    GO

ALTER TABLE [dbo].[stock_count_record] ADD [last_invest] varchar(255) NULL
    GO

ALTER TABLE [dbo].[stock_count_record] ADD [sum] varchar(255) NULL
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'父级料号',
    'SCHEMA', N'dbo',
    'TABLE', N'stock_count_record',
    'COLUMN', N'last_material'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'父级投入数',
    'SCHEMA', N'dbo',
    'TABLE', N'stock_count_record',
    'COLUMN', N'last_invest'
    GO

    EXEC sp_addextendedproperty
    'MS_Description', N'结转数',
    'SCHEMA', N'dbo',
    'TABLE', N'stock_count_record',
    'COLUMN', N'sum'